Exploratory Analysis of table named_place¶

Table extract¶

Shape:  (127420, 17)
pk_named_place concat_napl concat_standard_name begin_year end_year standard_latitude standard_longitude notes creator creation_time modifier modification_time fk_abob_type_napl notes_begin certainty_begin notes_end certainty_end
82419 61696.0 NaPl61696 Castron NaN NaN 43.9066 0.866847 NaN 4.0 2009-11-05 17:50:27.000 4.0 2014-12-03 16:46:04 156.0 NaN NaN NaN NaN
7467 23054.0 NaPl23054 Sainte-Marthe NaN NaN NaN NaN Commune existante au 1er janvier 2009. Importe... 4.0 2009-10-28 16:09:51.000 4.0 2014-12-03 17:04:13 697.0 NaN NaN NaN NaN
17998 32979.0 NaPl32979 Poiseul NaN NaN NaN NaN Commune existante au 1er janvier 2009. Importe... 4.0 2009-10-28 16:13:22.000 4.0 2014-12-03 17:04:13 697.0 NaN NaN NaN NaN
36882 44039.0 NaPl44039 Rouen NaN NaN NaN NaN Commune existante au 1er janvier 2009. Importe... 4.0 2009-10-28 16:14:05.000 4.0 2014-12-03 17:04:13 697.0 NaN NaN NaN NaN
110972 84437.0 NaPl84437 Mlay NaN NaN 47.7401 3.946170 NaN 4.0 2009-11-05 17:51:50.000 4.0 2014-12-03 16:46:04 156.0 NaN NaN NaN NaN

Discovery¶

Columns contain:
Total number of rows: 127420
  -       "pk_named_place":   0.00% empty - 127420 (100.00%) uniques (eg: 15922.0; 15923.0)
  -          "concat_napl":   0.00% empty - 127420 (100.00%) uniques (eg: NaPl15922; NaPl15923)
  - "concat_standard_name":   0.00% empty -  84480 ( 66.30%) uniques (eg: Vbre; Ventenac)
  -    "fk_abob_type_napl":   0.00% empty -      6 (  0.00%) uniques (eg: 697.0; 156.0)
  -    "modification_time":   0.00% empty -   1499 (  1.18%) uniques (eg: 2014-12-03...; 2014-12-03...)
  -        "creation_time":   0.00% empty -   2541 (  1.99%) uniques (eg: 2009-10-28...; 2010-03-03...)
  -              "creator":   0.00% empty -     50 (  0.04%) uniques (eg: 4.0; 26.0)
  -             "modifier":   0.00% empty -     48 (  0.04%) uniques (eg: 4.0; 26.0)
  -    "standard_latitude":  32.64% empty -  68972 ( 54.13%) uniques (eg: nan; 46.983333)
  -   "standard_longitude":  32.64% empty -  78600 ( 61.69%) uniques (eg: nan; 2.25)
  -                "notes":  39.35% empty -   1198 (  0.94%) uniques (eg: Commune ex...; nan)
  -        "certainty_end":  95.75% empty -      4 (  0.00%) uniques (eg: nan; 1.0)
  -      "certainty_begin":  95.77% empty -      4 (  0.00%) uniques (eg: nan; 1.0)
  -           "begin_year":  95.85% empty -    279 (  0.22%) uniques (eg: nan; 1700.0)
  -          "notes_begin":  96.13% empty -      5 (  0.00%) uniques (eg: nan; 4.0)
  -             "end_year":  96.16% empty -    107 (  0.08%) uniques (eg: nan; 1800.0)
  -            "notes_end":  96.23% empty -      5 (  0.00%) uniques (eg: nan; 3.0)

Type parsing¶

According to the table before, we will parse each column by the most meaningful type.

Columns analysis¶

Here we will report analysis of interesting information found on different columns. They are not exhaustive.

fk_abob_type_napl (type de place)¶

certainty_begin¶

We replace the not filled values by 0.

begin_year¶

certainty_end¶

We replace the not filled values by 0.

end_year¶

creation_time¶

creator¶